e0603258d5ec0702a0a0610aa3b680c8c9a44b09,sonar-core/src/main/java/org/sonar/core/persistence/DryRunDatabaseFactory.java,DryRunDatabaseFactory,copy,#DataSource#DataSource#number#,65
Before Change
private void copy(DataSource source, DataSource dest, int resourceId) {
new DbTemplate()
.copyTable(source, dest, "PROPERTIES",
"SELECT * FROM PROPERTIES WHERE (((USER_ID IS NULL) AND (RESOURCE_ID IS NULL)) OR (RESOURCE_ID='" + resourceId +
"')) AND NOT (PROP_KEY LIKE '%.secured')")
.copyTable(source, dest, "RULES_PROFILES", "SELECT * FROM RULES_PROFILES")
.copyTable(source, dest, "RULES", "SELECT * FROM RULES")
.copyTable(source, dest, "RULES_PARAMETERS", "SELECT * FROM RULES_PARAMETERS")
.copyTable(source, dest, "ACTIVE_RULES", "SELECT * FROM ACTIVE_RULES")
.copyTable(source, dest, "ACTIVE_RULE_PARAMETERS", "SELECT * FROM ACTIVE_RULE_PARAMETERS")
.copyTable(source, dest, "METRICS", "SELECT * FROM METRICS")
.copyTable(source, dest, "CHARACTERISTICS", "SELECT * FROM CHARACTERISTICS")
.copyTable(source, dest, "CHARACTERISTIC_PROPERTIES", "SELECT * FROM CHARACTERISTIC_PROPERTIES")
.copyTable(source, dest, "CHARACTERISTIC_EDGES", "SELECT * FROM CHARACTERISTIC_EDGES")
.copyTable(source, dest, "QUALITY_MODELS", "SELECT * FROM QUALITY_MODELS");
}
private BasicDataSource create(String dialect, String driver, String user, String password, String url) {
After Change
}
private void copy(DataSource source, DataSource dest, Integer resourceId) {
String notSecured = "NOT (PROP_KEY LIKE '%.secured')";
String defaultProperty = "((USER_ID IS NULL) AND (RESOURCE_ID IS NULL))";
String projectProperty = (null == resourceId) ? "" : " OR (RESOURCE_ID='" + resourceId + "')";
new DbTemplate()
.copyTable(source, dest, "ACTIVE_RULES", "SELECT * FROM ACTIVE_RULES")
.copyTable(source, dest, "ACTIVE_RULE_PARAMETERS", "SELECT * FROM ACTIVE_RULE_PARAMETERS")
.copyTable(source, dest, "CHARACTERISTICS", "SELECT * FROM CHARACTERISTICS")
.copyTable(source, dest, "CHARACTERISTIC_EDGES", "SELECT * FROM CHARACTERISTIC_EDGES")
.copyTable(source, dest, "CHARACTERISTIC_PROPERTIES", "SELECT * FROM CHARACTERISTIC_PROPERTIES")
.copyTable(source, dest, "METRICS", "SELECT * FROM METRICS")
.copyTable(source, dest, "PROPERTIES", "SELECT * FROM PROPERTIES WHERE " + notSecured + " AND (" + defaultProperty + projectProperty + ")")
.copyTable(source, dest, "QUALITY_MODELS", "SELECT * FROM QUALITY_MODELS")
.copyTable(source, dest, "RULES", "SELECT * FROM RULES")
.copyTable(source, dest, "RULES_PARAMETERS", "SELECT * FROM RULES_PARAMETERS")
.copyTable(source, dest, "RULES_PROFILES", "SELECT * FROM RULES_PROFILES");
}